Tabela StockCostLimitUsed

Definicja tabeli StockCostLimitUsed

Name

StockCostLimitUsed

Code

StockCostLimitUsed

Comment

Tabela przechowujaca wykorzystania poszczególnych limitów przez dane elementy (Jednostki, Apteczki, Pacjentów ...)


Lista kolumn tabeli StockCostLimitUsed

Name

Code

StockCostLimitUsedID

StockCostLimitUsedID

StockCostLimitID

StockCostLimitID

EpisodeID

EpisodeID

EventID

EventID

InsertDT

InsertDT

InsertingPerson

InsertingPerson

LastModifiedDT

LastModifiedDT

LastModifiedPerson

LastModifiedPerson

Cost

Cost


Kolumna StockCostLimitUsedID tabeli StockCostLimitUsed

Definicja kolumny StockCostLimitUsedID tabeli StockCostLimitUsed

Name

StockCostLimitUsedID

Code

StockCostLimitUsedID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StockCostLimitID tabeli StockCostLimitUsed

Definicja kolumny StockCostLimitID tabeli StockCostLimitUsed

Name

StockCostLimitID

Code

StockCostLimitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EpisodeID tabeli StockCostLimitUsed

Definicja kolumny EpisodeID tabeli StockCostLimitUsed

Name

EpisodeID

Code

EpisodeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli StockCostLimitUsed

Definicja kolumny EventID tabeli StockCostLimitUsed

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InsertDT tabeli StockCostLimitUsed

Definicja kolumny InsertDT tabeli StockCostLimitUsed

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

No

Comment

Data wygenerowania danej faktury i/lub paragonu


Kolumna InsertingPerson tabeli StockCostLimitUsed

Definicja kolumny InsertingPerson tabeli StockCostLimitUsed

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli StockCostLimitUsed

Definicja kolumny LastModifiedDT tabeli StockCostLimitUsed

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna LastModifiedPerson tabeli StockCostLimitUsed

Definicja kolumny LastModifiedPerson tabeli StockCostLimitUsed

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Cost tabeli StockCostLimitUsed

Definicja kolumny Cost tabeli StockCostLimitUsed

Name

Cost

Code

Cost

Data Type

NUMBER(12,4)

Mandatory

No

Comment

 


Lista kluczy tabeli StockCostLimitUsed

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli StockCostLimitUsed

Definicja klucza Identifier_1 tabeli StockCostLimitUsed

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment